[dbo].[asi_GetAddressByEmail]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.asi_GetAddressByEmail
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@email
nvarchar
1
SQL Script
CREATE
PROCEDURE
[dbo]
.
[asi_GetAddressByEmail]
(
@email
nvarchar
)
AS
BEGIN
SELECT
AddressKey
FROM
AddressMain
WHERE
AddressCategoryCode
=
4
AND
LOWER
(
FormattedAddress
)
=
LOWER
(
@email
)
END
GO
Uses
[dbo].[AddressMain]
dbo
[dbo].[asi_GetAddressByEmail] [dbo].[asi_GetAddressByEmail]